Indexes

Indexes are optional structures associated with tables and clusters. You can create indexes on one or more columns of a table to speed SQL statement execution on that table. An Oracle Database index provides a faster access path to table data. Indexes are the primary means of reducing disk I/O when properly used.

You can create many indexes for a table as long as the combination of columns differs for each index. You can create more than one index using the same columns if you specify distinctly different combinations of the columns.

Table indexes are managed on the Indexes tab of the Table Designer. Just simply click an index field for editing. By using the toolbar below, you can create new, edit and delete the selected index field.

Add Index

To add a table index

Edit Index

To edit a table index

Delete Index

To delete a table index


See also:
Setting Index Properties